随机抽取ACCESS数据库中的20条数据

代码在后台中

protected void Page_Load(object sender, EventArgs e)
    {
        Random rnd = new Random(unchecked((int)DateTime.Now.Ticks));
        int intRandomNumber = rnd.Next();
        superConn scnn = new superConn("biaozhunwenzhang.mdb");
        scnn.open();
        string str_sql = "SELECT top 20  wenzhang.ID, wenzhang.tm, leibie1.leibie1, leibie2.leibie2, wenzhang.neirong, wenzhang.rq, wenzhang.clj, wenzhang.sfxs  FROM (wenzhang LEFT JOIN leibie1 ON wenzhang.leibie1_id = leibie1.ID) LEFT JOIN leibie2 ON wenzhang.leibie2_id = leibie2.ID where (((sfxs = true))and((leibie1='小笑话')))  ORDER BY Rnd(" + (-1 * intRandomNumber) + "*wenzhang.ID)";
        OleDbDataReader dr = scnn.GetDataReader(str_sql);
        int i = 1;
        while (dr.Read())
        {
            
            Label_leibie.Text = Label_leibie.Text + "<br/><br/>" + i + ">【" + dr["tm"].ToString() + "】<br/>" + dr["neirong"].ToString();
            i = i + 1;
        }
        scnn.close();


        ///*如果用户登录，并且是特高级用户可以直接使用*/

        //if (Session["UserID"] != "")
        //{
        //    try
        //    {

        //        int dengji = int.Parse(Session["dengji"].ToString());

        //        if (dengji < 9)
        //        {
        //            Response.Redirect("productlist.aspx");
        //        }



        //    }
        //    catch { Response.Redirect("productlist.aspx"); }

        //}
        //else { Response.Redirect("productlist.aspx"); } 
        
        
        
        
        
        ///*如果用户登录，并且是特高级用户可以直接使用*/

        
        //string leibie = "";
        //if (Request.Params["leibie"] != null)
        //{
        //    leibie = Request.Params["leibie"].ToString();
        //}

        //Label_leibie.Text = leibie;
    }